create procedure GetAttendanceListDate
@employeeNo nvarchar(50),
@companyNo numeric(2,0),
@dayFrom numeric(8,0),
@dayTo	numeric(8,0)
as
begin
SELECT [WORK_DATE],[START_TIME],[END_TIME],[TIME_TABLE_NO],[WORK_TYPE_NO],
[UPDATE_START_TIME],[UPDATE_END_TIME],[REST_TIME],[WORKING_TIME],[OVER_TIME],
[LATE_NIGHT_TIME],[HOLIDAY_TIME],[HOLIDAY_LATE_NIGHT_TIME],[BEING_LATE_TIME],
[LEAVING_EARLY_TIME], WORK_DATA.MEMO
FROM [dbo].[WORK_DATA] where COMPANY_NO = @companyNo  and EMPLOYEE_NO = @employeeNo 
and WORK_DATE between @dayFrom and  @dayTo
end
